Freelance projects

Freelance projects

Data extraction from 1C "Fitness Club 3.6" (OData or processing)

Databases & SQL — incorrectly specified categories?

16 USD

Project translated automatically. Log in or register, to view the original

# What is

- **1C:Enterprise 8.3.17.1549**, configuration **“Fitness Club” version 3.6** (standard).

- **File database**, directory `D:\1c\FC`. **Thick client**, standard interface.

- OS **Windows 7**, computer in the club, runs continuously. HASP license (local flash drive).

- Access will be provided via **AnyDesk / TeamViewer**.

## Problem to solve

In this interface (thick client) **there is no menu item for configuring OData warehouse** —

it cannot be enabled through buttons. It needs to be done via code / processing.

## Task (choose the simpler one — ~1-2 hours)

### Option A — OData

1. Install a web server (Apache 2.4 / IIS) on this PC.

2. Publish the file database with **the standard OData interface enabled**.

3. **Set the OData warehouse via code** (`SetWarehouseStandardODataInterface`) —

open for reading: clients, subscriptions, barcodes/cards, visits, balances.

4. Create a user `integration` (login+password, read rights).

5. Check: `http://localhost/<;database>/odata/standard.odata/` returns data.

### Option B — Simple processing-export (may be easier for this configuration)

1. Write an external processing (.epf) that exports:

- clients (full name, phone, **card barcode**),

- active subscriptions (type, remaining workouts, expiration date),

- (if possible) visits.

2. Format: **JSON**, and send POST to our webhook (address will be provided) — OR save to a file,

which syncs to the cloud.

3. Schedule it (regular task / Windows Scheduler) — once every 15-30 minutes.

## Important

- **Do not change/rewrite anything in the configuration.** Only export data externally.

- **Do not expose the database to the internet** (Win7 is old). Local is sufficient — sending to the cloud will be handled on our side.

- The key field for client linkage — **card barcode** (e.g. 2100000016853).

## What to provide after work

- How it was done (OData address + login/password, OR export-processing format).

- Names of objects in the configuration: what the client directory is called, where the barcode is stored,

where the subscription and remaining workouts are (so I can match it with the application).

Proposals 7 Discussions 2

Oleg Grigoryev

32 0

Budget: 3500 UAH Deadline: 1 day

I can take this as a short technical stage - a guideline of 1 working day, 3500 UAH. 700 UAH here seems too little even for a careful diagnostics of 1C on Win7, because it’s not just about pressing a button, but checking the OData structure, permissions, configuration objects, and safely performing the export without changing the configuration itself =/

I would approach it pragmatically - first, I would quickly check if it’s possible to raise the standard OData specifically for this file database and version. If it leads to a dead end, we won’t heroically bang our heads against Apache - we’ll create an external processing .epf with JSON export of clients, cards, active subscriptions, and, if the configuration provides normal connections, visits. I will separately provide the names of directories, registers, and fields where the card barcode and balances are stored.

I will clarify 2 points before final evaluation:
> is there access to the configurator with administrator rights
> where is it safer to place the result - a local file for synchronization or a POST to your webhook

Similar logical system works by Ingello:
> https://business.ingello.com/iks - corporate system with accounting and business logic
> https://business.ingello.com/forma-bpm - process automation and data transfer between parts of the system
> https://systems-fl.ingello.com/ua - main page for such tasks

After the work, I will leave a short instruction, access for integration if we go through OData, or a description of the JSON format and the schedule launch scheme. Note, there’s a nuance - we do not expose the database on the internet, it’s better not to test Win7 for strength, because security loves silence.

Similar project: Рефаткоринг приложения

Bohdan Melnyk

Winning proposal

2 0

Projects -
Rating -
Rating 478

Budget: 700 UAH Deadline: 2 days

Good day! I was doing data export from 1C externally — I raised OData, provided data via HTTP, and set up a schedule, so your case with the fitness club is clear to me. I will collect clients with a card barcode, subscriptions with remaining sessions and expiration, compile them in JSON, and send them to your webhook every 15-30 minutes — I won't change anything in the configuration, just read. One clarification: is OData already enabled in the database, or should it be activated on the 1C side as well? I will complete it in a couple of days.

Kirilo Biloshytsky

42 0

Budget: 2000 UAH Deadline: 1 day

Hello!
I am ready to take on your project and will complete it urgently.
I have extensive experience with similar tasks, and there will be no difficulties.
If I have piqued your interest, feel free to write; I am happy to collaborate!

Daria Kratofil

0 0

Projects -
Rating -
Rating 196

Budget: 4500 UAH Deadline: 1 day

We already have a practically ready similar solution for exporting data from 1C to JSON or via OData, we can quickly adapt it for Fitness Club 3.6 and launch it without configuration changes.
I can take it through a short technical phase - first, I will check OData and the composition of objects; if there are limitations on Win7 or in the thick client, I will create an external processing .epf with sending to a webhook or to a file.
Regarding the timeline - 1 working day after access to the PC, database, and webhook.
Cost - 4500 UAH.
An important emphasis - I do not touch the configuration, I work only through publication or external processing, we keep the connection key through !!barcode of the card!!.
From your side, access to the PC, the path to the database, 1C user data with read rights or permission to create integration, and the webhook address if we go through POST are needed.
Please let me know, does the webhook already accept test JSON?
Is there a test copy of the database, or do we work on the live one after a backup of the file?
https://business.ingello.com/forma-crm - similar in working with client data, roles, and CRM structure.
https://business.ingello.com/forma-bpm - similar in regular exchanges and process automation.
https://systems-fl.ingello.com/ua - briefly about us and the format of work on the exchange.
Overall, it's fine, the task is narrow, but in 1C, small things like to pretend to be philosophy - so I would first check OData, and then without heroism, I would make a reliable setup through .epf =/

Oleksandr Havrilenko

73 2

Budget: 800 UAH Deadline: 2 days

Option A cannot be implemented without changing the configuration. Therefore, only option B remains. I am ready to complete your task. I guarantee the work done. The calculation of the exact cost will be after discussing all the details.